
<!DOCTYPE HTML>
<html lang="" >
    <head>
        <meta charset="UTF-8">
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
        <title>oracle · GitBook</title>
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <meta name="description" content="">
        <meta name="generator" content="GitBook 3.2.3">
        
        
        
    
    <link rel="stylesheet" href="../gitbook/style.css">

    
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-highlight/website.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-fontsettings/website.css">
                
            
        

    

    
        
    
        
    
        
    
        
    
        
    
        
    

        
    
    
    <meta name="HandheldFriendly" content="true"/>
    <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <link rel="apple-touch-icon-precomposed" sizes="152x152" href="../gitbook/images/apple-touch-icon-precomposed-152.png">
    <link rel="shortcut icon" href="../gitbook/images/favicon.ico" type="image/x-icon">

    
    <link rel="next" href="redis.html" />
    
    
    <link rel="prev" href="node.js.html" />
    

    </head>
    <body>
        
<div class="book">
    <div class="book-summary">
        
            
            
                <nav role="navigation">
                


<ul class="summary">
    
    

    

    
        
        
    
        <li class="chapter " data-level="1.1" data-path="../">
            
                <a href="../">
            
                    
                    starting
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2" data-path="../INTRODUCTION.html">
            
                <a href="../INTRODUCTION.html">
            
                    
                    introduction
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3" >
            
                <span>
            
                    
                    algorithm
            
                </span>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.3.1" data-path="../algorithm/graphic_processing/">
            
                <a href="../algorithm/graphic_processing/">
            
                    
                    graphic_processing
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.2" data-path="../algorithm/machine_learning/">
            
                <a href="../algorithm/machine_learning/">
            
                    
                    machine_learning
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.3" data-path="../algorithm/other/">
            
                <a href="../algorithm/other/">
            
                    
                    other
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.4" >
            
                <span>
            
                    
                    language
            
                </span>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.4.1" data-path="../language/cpp/">
            
                <a href="../language/cpp/">
            
                    
                    cpp
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.2" data-path="../language/golang/">
            
                <a href="../language/golang/">
            
                    
                    golang
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.3" data-path="../language/java/">
            
                <a href="../language/java/">
            
                    
                    java
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.4" data-path="../language/javascript/">
            
                <a href="../language/javascript/">
            
                    
                    javascript
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.5" data-path="../language/python/">
            
                <a href="../language/python/">
            
                    
                    python
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.5" >
            
                <span>
            
                    
                    soft_skills
            
                </span>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.5.1" data-path="docker.html">
            
                <a href="docker.html">
            
                    
                    docker
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.2" data-path="git.html">
            
                <a href="git.html">
            
                    
                    git
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.3" data-path="ideaj.html">
            
                <a href="ideaj.html">
            
                    
                    ideaj
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.4" data-path="linux.html">
            
                <a href="linux.html">
            
                    
                    linux
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.5" data-path="maven.html">
            
                <a href="maven.html">
            
                    
                    maven
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.6" data-path="mysql.html">
            
                <a href="mysql.html">
            
                    
                    mysql
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.7" data-path="nginx.html">
            
                <a href="nginx.html">
            
                    
                    nginx
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.8" data-path="node.js.html">
            
                <a href="node.js.html">
            
                    
                    node.js
            
                </a>
            

            
        </li>
    
        <li class="chapter active" data-level="1.5.9" data-path="oracle.html">
            
                <a href="oracle.html">
            
                    
                    oracle
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.10" data-path="redis.html">
            
                <a href="redis.html">
            
                    
                    redis
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.11" data-path="script.html">
            
                <a href="script.html">
            
                    
                    script
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.12" data-path="skill.html">
            
                <a href="skill.html">
            
                    
                    skill
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.13" data-path="tcp-ip.html">
            
                <a href="tcp-ip.html">
            
                    
                    tcp-ip
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.14" data-path="ubuntu.html">
            
                <a href="ubuntu.html">
            
                    
                    ubuntu
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.15" data-path="vscode.html">
            
                <a href="vscode.html">
            
                    
                    vscode
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.16" data-path="windows.html">
            
                <a href="windows.html">
            
                    
                    windows
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    

    

    <li class="divider"></li>

    <li>
        <a href="https://www.gitbook.com" target="blank" class="gitbook-link">
            Published with GitBook
        </a>
    </li>
</ul>


                </nav>
            
        
    </div>

    <div class="book-body">
        
            <div class="body-inner">
                
                    

<div class="book-header" role="navigation">
    

    <!-- Title -->
    <h1>
        <i class="fa fa-circle-o-notch fa-spin"></i>
        <a href=".." >oracle</a>
    </h1>
</div>




                    <div class="page-wrapper" tabindex="-1" role="main">
                        <div class="page-inner">
                            
                                <section class="normal markdown-section">
                                
                                <h3 id="&#x8FDE;&#x63A5;-oracle">&#x8FDE;&#x63A5; Oracle</h3>
<p>&#x8FDE;&#x63A5; Oracle &#x8981;&#x6C42;&#x670D;&#x52A1;&#x7AEF;&#x548C;&#x5BA2;&#x6237;&#x7AEF;&#x7684; oci.dll &#x76F8;&#x540C;&#xFF0C;&#x800C;&#x5BA2;&#x6237;&#x7AEF;&#x81EA;&#x5E26;&#x7684; oci.dll &#x4E00;&#x822C;&#x662F; Oracle 10 &#x7684;&#xFF0C;&#x6240;&#x4EE5;&#x9700;&#x8981;&#x53BB;&#x4E0B;&#x8F7D;&#x76F8;&#x5E94;&#x7248;&#x672C;&#x7684; <a href="https://www.oracle.com/database/technologies/instant-client/downloads.html" target="_blank">Oracle Instance Client</a>&#xFF0C;&#x6700;&#x540E;&#x5728;&#x5BA2;&#x6237;&#x7AEF;&#x4E0A;&#x914D;&#x7F6E; oci.dll &#x7684;&#x8DEF;&#x5F84;&#xFF08;&#x6CE8;&#x610F;&#xFF0C;&#x4E0B;&#x8F7D;&#x65F6;&#x9700;&#x8981;&#x6E05;&#x695A;&#x5BA2;&#x6237;&#x7AEF;&#x662F; 32bit &#x8FD8;&#x662F; 64bit &#x7684;&#xFF09;</p>
<p>&#x5BA2;&#x6237;&#x7AEF;</p>
<ul>
<li>Navicat&#xFF0C;&#x53EA;&#x9700;&#x8981;&#x914D;&#x7F6E; oci.dll</li>
<li>PLSQL Developer&#xFF0C;&#x9700;&#x8981;&#x914D;&#x7F6E; oci.dll &#x548C; oci.dll &#x6240;&#x5728;&#x76EE;&#x5F55;&#xFF0C;&#x5E76;&#x4E14;&#x9700;&#x8981;&#x5728;&#x4E3B;&#x673A;&#x4E0A;&#x914D;&#x7F6E;&#x73AF;&#x5883;&#x53D8;&#x91CF; <code>NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK</code></li>
</ul>
<hr>
<h3 id="&#x6388;&#x6743;&#x4E0E;&#x540C;&#x4E49;&#x8BCD;">&#x6388;&#x6743;&#x4E0E;&#x540C;&#x4E49;&#x8BCD;</h3>
<pre><code class="lang-sql"><span class="hljs-comment">-- &#x6388;&#x6743;</span>
<span class="hljs-keyword">GRANT</span> <span class="hljs-keyword">SELECT</span> <span class="hljs-keyword">ON</span> prpcplan <span class="hljs-keyword">TO</span> utic_claimcaruser;
<span class="hljs-comment">-- &#x4E3A;&#x88AB;&#x6388;&#x6743;&#x7528;&#x6237;&#x521B;&#x5EFA;&#x540C;&#x4E49;&#x8BCD;</span>
<span class="hljs-keyword">CREATE</span> <span class="hljs-keyword">SYNONYM</span> utic_claimcaruser.prpcplan <span class="hljs-keyword">FOR</span> busiuser.prpcplan;
</code></pre>
<hr>

                                
                                </section>
                            
                        </div>
                    </div>
                
            </div>

            
                
                <a href="node.js.html" class="navigation navigation-prev " aria-label="Previous page: node.js">
                    <i class="fa fa-angle-left"></i>
                </a>
                
                
                <a href="redis.html" class="navigation navigation-next " aria-label="Next page: redis">
                    <i class="fa fa-angle-right"></i>
                </a>
                
            
        
    </div>

    <script>
        var gitbook = gitbook || [];
        gitbook.push(function() {
            gitbook.page.hasChanged({"page":{"title":"oracle","level":"1.5.9","depth":2,"next":{"title":"redis","level":"1.5.10","depth":2,"path":"soft_skills/redis.md","ref":"soft_skills/redis.md","articles":[]},"previous":{"title":"node.js","level":"1.5.8","depth":2,"path":"soft_skills/node.js.md","ref":"soft_skills/node.js.md","articles":[]},"dir":"ltr"},"config":{"gitbook":"*","theme":"default","variables":{},"plugins":["-search","-sharing","-lunr"],"pluginsConfig":{"highlight":{},"fontsettings":{"theme":"white","family":"sans","size":2},"theme-default":{"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"showLevel":false}},"structure":{"langs":"LANGS.md","readme":"README.md","glossary":"GLOSSARY.md","summary":"SUMMARY.md"},"pdf":{"pageNumbers":true,"fontSize":12,"fontFamily":"Arial","paperSize":"a4","chapterMark":"pagebreak","pageBreaksBefore":"/","margin":{"right":62,"left":62,"top":56,"bottom":56}},"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"}},"file":{"path":"soft_skills/oracle.md","mtime":"2020-02-07T09:47:14.340Z","type":"markdown"},"gitbook":{"version":"3.2.3","time":"2020-03-17T16:45:36.070Z"},"basePath":"..","book":{"language":""}});
        });
    </script>
</div>

        
    <script src="../gitbook/gitbook.js"></script>
    <script src="../gitbook/theme.js"></script>
    
        
        <script src="../gitbook/gitbook-plugin-fontsettings/fontsettings.js"></script>
        
    

    </body>
</html>

